Quiz: Spreadsheet Functions

Functions

QUIZ QUESTION::

Match the following functions with definitions. You may need to use use "help" in your spreadsheet application or look in the Formulas menu to find out more about these functions.

ANSWER CHOICES:

Definition	Function
Converts a text string to upper case letters.
Returns the logical value TRUE.
Returns the number of characters in a text string.
Estimates standard deviation based on a sample (ignores logical values and text).
Adds all the numbers in a range of cells.
Removes all spaces from a text string except single spaces between words.

SOLUTION:

Definition	Function
Adds all the numbers in a range of cells.
Converts a text string to upper case letters.
Removes all spaces from a text string except single spaces between words.
Estimates standard deviation based on a sample (ignores logical values and text).
Returns the logical value TRUE.
Returns the number of characters in a text string.